import dao.UserDao;
import model.Article;
import model.JDBCUtil;
import model.User;
import model.Userfocus;
import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;


import java.io.Serializable;
import java.util.*;

public class test1 implements Serializable {

    @Test
    public void test1() {
        UserDao userDao = new UserDao();
        JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBCUtil.getDataSource());
        List<Map<String, Object>> list = jdbcTemplate.queryForList("SELECT email FROM user");
        for (Map<String, Object> mao : list) {
            System.out.println(mao.get("email"));
        }
    }
}
